How to: Format titles across columns.
Solution:
Select the columns (including the text to be centered), then select 'Cells...' from the 'Format' menu. Click 'Alignment' tab, then select the 'Center Across Selection' radio button.
1) Select the columns including the text to be centered.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Alignment' tab.
4) Select the 'Center Across Selection' radio button from the 'Horizontal' group.
5) Click 'OK'.
